Dataset statistics
| Number of variables | 18 |
|---|---|
| Number of observations | 8950 |
| Missing cells | 314 |
| Missing cells (%) | 0.2% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.2 MiB |
| Average record size in memory | 144.0 B |
Variable types
| Categorical | 1 |
|---|---|
| Numeric | 17 |
CUST_ID has a high cardinality: 8950 distinct values | High cardinality |
BALANCE is highly overall correlated with BALANCE_FREQUENCY and 4 other fields | High correlation |
BALANCE_FREQUENCY is highly overall correlated with BALANCE and 1 other fields | High correlation |
PURCHASES is highly overall correlated with ONEOFF_PURCHASES and 5 other fields | High correlation |
ONEOFF_PURCHASES is highly overall correlated with PURCHASES and 2 other fields | High correlation |
INSTALLMENTS_PURCHASES is highly overall correlated with PURCHASES and 3 other fields | High correlation |
CASH_ADVANCE is highly overall correlated with BALANCE and 2 other fields | High correlation |
PURCHASES_FREQUENCY is highly overall correlated with PURCHASES and 3 other fields | High correlation |
ONEOFF_PURCHASES_FREQUENCY is highly overall correlated with PURCHASES and 2 other fields | High correlation |
PURCHASES_INSTALLMENTS_FREQUENCY is highly overall correlated with PURCHASES and 3 other fields | High correlation |
CASH_ADVANCE_FREQUENCY is highly overall correlated with BALANCE and 2 other fields | High correlation |
CASH_ADVANCE_TRX is highly overall correlated with BALANCE and 2 other fields | High correlation |
PURCHASES_TRX is highly overall correlated with PURCHASES and 5 other fields | High correlation |
MINIMUM_PAYMENTS is highly overall correlated with BALANCE and 1 other fields | High correlation |
MINIMUM_PAYMENTS has 313 (3.5%) missing values | Missing |
CUST_ID is uniformly distributed | Uniform |
CUST_ID has unique values | Unique |
PURCHASES has 2044 (22.8%) zeros | Zeros |
ONEOFF_PURCHASES has 4302 (48.1%) zeros | Zeros |
INSTALLMENTS_PURCHASES has 3916 (43.8%) zeros | Zeros |
CASH_ADVANCE has 4628 (51.7%) zeros | Zeros |
PURCHASES_FREQUENCY has 2043 (22.8%) zeros | Zeros |
ONEOFF_PURCHASES_FREQUENCY has 4302 (48.1%) zeros | Zeros |
PURCHASES_INSTALLMENTS_FREQUENCY has 3915 (43.7%) zeros | Zeros |
CASH_ADVANCE_FREQUENCY has 4628 (51.7%) zeros | Zeros |
CASH_ADVANCE_TRX has 4628 (51.7%) zeros | Zeros |
PURCHASES_TRX has 2044 (22.8%) zeros | Zeros |
PAYMENTS has 240 (2.7%) zeros | Zeros |
PRC_FULL_PAYMENT has 5903 (66.0%) zeros | Zeros |
Reproduction
| Analysis started | 2023-06-10 08:24:43.627685 |
|---|---|
| Analysis finished | 2023-06-10 08:26:28.278395 |
| Duration | 1 minute and 44.65 seconds |
| Software version | ydata-profiling vv4.1.2 |
| Download configuration | config.json |
CUST_ID
Categorical
HIGH CARDINALITY UNIFORM UNIQUE
| Distinct | 8950 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 70.0 KiB |
| C10001 | 1 |
|---|---|
| C16135 | 1 |
| C16129 | 1 |
| C16130 | 1 |
| C16131 | 1 |
| Other values (8945) |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Characters and Unicode
| Total characters | 53700 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 8950 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | C10001 |
|---|---|
| 2nd row | C10002 |
| 3rd row | C10003 |
| 4th row | C10004 |
| 5th row | C10005 |
Common Values
| Value | Count | Frequency (%) |
| C10001 | 1 | < 0.1% |
| C16135 | 1 | < 0.1% |
| C16129 | 1 | < 0.1% |
| C16130 | 1 | < 0.1% |
| C16131 | 1 | < 0.1% |
| C16132 | 1 | < 0.1% |
| C16133 | 1 | < 0.1% |
| C16134 | 1 | < 0.1% |
| C16136 | 1 | < 0.1% |
| C16144 | 1 | < 0.1% |
| Other values (8940) | 8940 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| c10001 | 1 | < 0.1% |
| c10011 | 1 | < 0.1% |
| c10017 | 1 | < 0.1% |
| c10016 | 1 | < 0.1% |
| c10015 | 1 | < 0.1% |
| c10014 | 1 | < 0.1% |
| c10013 | 1 | < 0.1% |
| c10012 | 1 | < 0.1% |
| c10010 | 1 | < 0.1% |
| c10034 | 1 | < 0.1% |
| Other values (8940) | 8940 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 12672 | |
| C | 8950 | |
| 0 | 3737 | 7.0% |
| 2 | 3652 | 6.8% |
| 3 | 3651 | 6.8% |
| 5 | 3642 | 6.8% |
| 7 | 3640 | 6.8% |
| 4 | 3636 | 6.8% |
| 6 | 3633 | 6.8% |
| 8 | 3633 | 6.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 44750 | |
| Uppercase Letter | 8950 | 16.7% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 12672 | |
| 0 | 3737 | 8.4% |
| 2 | 3652 | 8.2% |
| 3 | 3651 | 8.2% |
| 5 | 3642 | 8.1% |
| 7 | 3640 | 8.1% |
| 4 | 3636 | 8.1% |
| 6 | 3633 | 8.1% |
| 8 | 3633 | 8.1% |
| 9 | 2854 | 6.4% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 8950 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 44750 | |
| Latin | 8950 | 16.7% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 12672 | |
| 0 | 3737 | 8.4% |
| 2 | 3652 | 8.2% |
| 3 | 3651 | 8.2% |
| 5 | 3642 | 8.1% |
| 7 | 3640 | 8.1% |
| 4 | 3636 | 8.1% |
| 6 | 3633 | 8.1% |
| 8 | 3633 | 8.1% |
| 9 | 2854 | 6.4% |
Latin
| Value | Count | Frequency (%) |
| C | 8950 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 53700 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 12672 | |
| C | 8950 | |
| 0 | 3737 | 7.0% |
| 2 | 3652 | 6.8% |
| 3 | 3651 | 6.8% |
| 5 | 3642 | 6.8% |
| 7 | 3640 | 6.8% |
| 4 | 3636 | 6.8% |
| 6 | 3633 | 6.8% |
| 8 | 3633 | 6.8% |
BALANCE
Real number (ℝ)
| Distinct | 8871 |
|---|---|
| Distinct (%) | 99.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1564.4748 |
| Minimum | 0 |
|---|---|
| Maximum | 19043.139 |
| Zeros | 80 |
| Zeros (%) | 0.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 8.8145184 |
| Q1 | 128.28192 |
| median | 873.38523 |
| Q3 | 2054.14 |
| 95-th percentile | 5909.1118 |
| Maximum | 19043.139 |
| Range | 19043.139 |
| Interquartile range (IQR) | 1925.8581 |
Descriptive statistics
| Standard deviation | 2081.5319 |
|---|---|
| Coefficient of variation (CV) | 1.3304988 |
| Kurtosis | 7.6747513 |
| Mean | 1564.4748 |
| Median Absolute Deviation (MAD) | 799.8652 |
| Skewness | 2.393386 |
| Sum | 14002050 |
| Variance | 4332775 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 80 | 0.9% |
| 40.900749 | 1 | < 0.1% |
| 1213.551338 | 1 | < 0.1% |
| 1253.188317 | 1 | < 0.1% |
| 5058.299635 | 1 | < 0.1% |
| 296.905944 | 1 | < 0.1% |
| 1084.652647 | 1 | < 0.1% |
| 237.198442 | 1 | < 0.1% |
| 1636.518315 | 1 | < 0.1% |
| 468.851415 | 1 | < 0.1% |
| Other values (8861) | 8861 |
| Value | Count | Frequency (%) |
| 0 | 80 | |
| 0.000199 | 1 | < 0.1% |
| 0.001146 | 1 | < 0.1% |
| 0.001214 | 1 | < 0.1% |
| 0.001289 | 1 | < 0.1% |
| 0.004816 | 1 | < 0.1% |
| 0.006651 | 1 | < 0.1% |
| 0.009684 | 1 | < 0.1% |
| 0.01968 | 1 | < 0.1% |
| 0.021102 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 19043.13856 | 1 | |
| 18495.55855 | 1 | |
| 16304.88925 | 1 | |
| 16259.44857 | 1 | |
| 16115.5964 | 1 | |
| 15532.33972 | 1 | |
| 15258.2259 | 1 | |
| 15244.74865 | 1 | |
| 15155.53286 | 1 | |
| 14581.45914 | 1 |
BALANCE_FREQUENCY
Real number (ℝ)
| Distinct | 43 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.87727073 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 80 |
| Zeros (%) | 0.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.272727 |
| Q1 | 0.888889 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.111111 |
Descriptive statistics
| Standard deviation | 0.236904 |
|---|---|
| Coefficient of variation (CV) | 0.27004663 |
| Kurtosis | 3.0923696 |
| Mean | 0.87727073 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.0232655 |
| Sum | 7851.573 |
| Variance | 0.056123506 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=43)
| Value | Count | Frequency (%) |
| 1 | 6211 | |
| 0.909091 | 410 | 4.6% |
| 0.818182 | 278 | 3.1% |
| 0.727273 | 223 | 2.5% |
| 0.545455 | 219 | 2.4% |
| 0.636364 | 209 | 2.3% |
| 0.454545 | 172 | 1.9% |
| 0.363636 | 170 | 1.9% |
| 0.272727 | 151 | 1.7% |
| 0.181818 | 146 | 1.6% |
| Other values (33) | 761 | 8.5% |
| Value | Count | Frequency (%) |
| 0 | 80 | |
| 0.090909 | 67 | |
| 0.1 | 8 | 0.1% |
| 0.111111 | 5 | 0.1% |
| 0.125 | 9 | 0.1% |
| 0.142857 | 7 | 0.1% |
| 0.166667 | 7 | 0.1% |
| 0.181818 | 146 | |
| 0.2 | 9 | 0.1% |
| 0.222222 | 5 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 6211 | |
| 0.909091 | 410 | 4.6% |
| 0.9 | 55 | 0.6% |
| 0.888889 | 53 | 0.6% |
| 0.875 | 57 | 0.6% |
| 0.857143 | 51 | 0.6% |
| 0.833333 | 60 | 0.7% |
| 0.818182 | 278 | 3.1% |
| 0.8 | 20 | 0.2% |
| 0.777778 | 22 | 0.2% |
PURCHASES
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 6203 |
|---|---|
| Distinct (%) | 69.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1003.2048 |
| Minimum | 0 |
|---|---|
| Maximum | 49039.57 |
| Zeros | 2044 |
| Zeros (%) | 22.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 39.635 |
| median | 361.28 |
| Q3 | 1110.13 |
| 95-th percentile | 3998.6195 |
| Maximum | 49039.57 |
| Range | 49039.57 |
| Interquartile range (IQR) | 1070.495 |
Descriptive statistics
| Standard deviation | 2136.6348 |
|---|---|
| Coefficient of variation (CV) | 2.1298091 |
| Kurtosis | 111.38877 |
| Mean | 1003.2048 |
| Median Absolute Deviation (MAD) | 361.28 |
| Skewness | 8.1442691 |
| Sum | 8978683.3 |
| Variance | 4565208.2 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 2044 | 22.8% |
| 45.65 | 27 | 0.3% |
| 60 | 16 | 0.2% |
| 150 | 16 | 0.2% |
| 300 | 13 | 0.1% |
| 200 | 13 | 0.1% |
| 100 | 13 | 0.1% |
| 450 | 12 | 0.1% |
| 50 | 10 | 0.1% |
| 600 | 10 | 0.1% |
| Other values (6193) | 6776 |
| Value | Count | Frequency (%) |
| 0 | 2044 | |
| 0.01 | 4 | < 0.1% |
| 0.05 | 1 | < 0.1% |
| 0.24 | 1 | < 0.1% |
| 0.7 | 1 | < 0.1% |
| 1 | 2 | < 0.1% |
| 1.4 | 1 | < 0.1% |
| 2 | 1 | < 0.1% |
| 4.44 | 1 | < 0.1% |
| 4.8 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 49039.57 | 1 | |
| 41050.4 | 1 | |
| 40040.71 | 1 | |
| 38902.71 | 1 | |
| 35131.16 | 1 | |
| 32539.78 | 1 | |
| 31299.35 | 1 | |
| 27957.68 | 1 | |
| 27790.42 | 1 | |
| 26784.62 | 1 |
ONEOFF_PURCHASES
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 4014 |
|---|---|
| Distinct (%) | 44.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 592.43737 |
| Minimum | 0 |
|---|---|
| Maximum | 40761.25 |
| Zeros | 4302 |
| Zeros (%) | 48.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 38 |
| Q3 | 577.405 |
| 95-th percentile | 2671.094 |
| Maximum | 40761.25 |
| Range | 40761.25 |
| Interquartile range (IQR) | 577.405 |
Descriptive statistics
| Standard deviation | 1659.8879 |
|---|---|
| Coefficient of variation (CV) | 2.8017948 |
| Kurtosis | 164.18757 |
| Mean | 592.43737 |
| Median Absolute Deviation (MAD) | 38 |
| Skewness | 10.045083 |
| Sum | 5302314.5 |
| Variance | 2755227.9 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 4302 | |
| 45.65 | 46 | 0.5% |
| 50 | 17 | 0.2% |
| 200 | 15 | 0.2% |
| 60 | 13 | 0.1% |
| 100 | 13 | 0.1% |
| 150 | 12 | 0.1% |
| 70 | 12 | 0.1% |
| 1000 | 12 | 0.1% |
| 250 | 11 | 0.1% |
| Other values (4004) | 4497 |
| Value | Count | Frequency (%) |
| 0 | 4302 | |
| 0.01 | 7 | 0.1% |
| 0.02 | 2 | < 0.1% |
| 0.05 | 1 | < 0.1% |
| 0.24 | 1 | < 0.1% |
| 0.7 | 1 | < 0.1% |
| 1 | 4 | < 0.1% |
| 1.4 | 2 | < 0.1% |
| 2 | 1 | < 0.1% |
| 4.99 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 40761.25 | 1 | |
| 40624.06 | 1 | |
| 34087.73 | 1 | |
| 33803.84 | 1 | |
| 26547.43 | 1 | |
| 26514.32 | 1 | |
| 25122.77 | 1 | |
| 24543.52 | 1 | |
| 23032.97 | 1 | |
| 22257.39 | 1 |
INSTALLMENTS_PURCHASES
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 4452 |
|---|---|
| Distinct (%) | 49.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 411.06764 |
| Minimum | 0 |
|---|---|
| Maximum | 22500 |
| Zeros | 3916 |
| Zeros (%) | 43.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 89 |
| Q3 | 468.6375 |
| 95-th percentile | 1750.0875 |
| Maximum | 22500 |
| Range | 22500 |
| Interquartile range (IQR) | 468.6375 |
Descriptive statistics
| Standard deviation | 904.33812 |
|---|---|
| Coefficient of variation (CV) | 2.199974 |
| Kurtosis | 96.575178 |
| Mean | 411.06764 |
| Median Absolute Deviation (MAD) | 89 |
| Skewness | 7.2991199 |
| Sum | 3679055.4 |
| Variance | 817827.43 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 3916 | |
| 300 | 14 | 0.2% |
| 200 | 14 | 0.2% |
| 100 | 14 | 0.2% |
| 150 | 12 | 0.1% |
| 125 | 11 | 0.1% |
| 75 | 9 | 0.1% |
| 350 | 8 | 0.1% |
| 450 | 8 | 0.1% |
| 500 | 8 | 0.1% |
| Other values (4442) | 4936 |
| Value | Count | Frequency (%) |
| 0 | 3916 | |
| 1.95 | 1 | < 0.1% |
| 4.44 | 1 | < 0.1% |
| 4.8 | 1 | < 0.1% |
| 6.33 | 1 | < 0.1% |
| 7.26 | 1 | < 0.1% |
| 7.67 | 1 | < 0.1% |
| 9.28 | 1 | < 0.1% |
| 9.58 | 1 | < 0.1% |
| 9.65 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 22500 | 1 | |
| 15497.19 | 1 | |
| 14686.1 | 1 | |
| 13184.43 | 1 | |
| 12738.47 | 1 | |
| 12560.85 | 1 | |
| 12541 | 1 | |
| 12375 | 1 | |
| 12235.05 | 1 | |
| 12128.94 | 1 |
CASH_ADVANCE
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 4323 |
|---|---|
| Distinct (%) | 48.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 978.87111 |
| Minimum | 0 |
|---|---|
| Maximum | 47137.212 |
| Zeros | 4628 |
| Zeros (%) | 51.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1113.8211 |
| 95-th percentile | 4647.1691 |
| Maximum | 47137.212 |
| Range | 47137.212 |
| Interquartile range (IQR) | 1113.8211 |
Descriptive statistics
| Standard deviation | 2097.1639 |
|---|---|
| Coefficient of variation (CV) | 2.1424311 |
| Kurtosis | 52.899434 |
| Mean | 978.87111 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.1666091 |
| Sum | 8760896.5 |
| Variance | 4398096.3 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 4628 | |
| 495.425832 | 1 | < 0.1% |
| 1486.243293 | 1 | < 0.1% |
| 855.232779 | 1 | < 0.1% |
| 3767.104707 | 1 | < 0.1% |
| 291.608512 | 1 | < 0.1% |
| 38.690552 | 1 | < 0.1% |
| 521.664369 | 1 | < 0.1% |
| 1974.202963 | 1 | < 0.1% |
| 2462.100789 | 1 | < 0.1% |
| Other values (4313) | 4313 |
| Value | Count | Frequency (%) |
| 0 | 4628 | |
| 14.222216 | 1 | < 0.1% |
| 18.042768 | 1 | < 0.1% |
| 18.117967 | 1 | < 0.1% |
| 18.123413 | 1 | < 0.1% |
| 18.126683 | 1 | < 0.1% |
| 18.149946 | 1 | < 0.1% |
| 18.204577 | 1 | < 0.1% |
| 18.240626 | 1 | < 0.1% |
| 18.280043 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 47137.21176 | 1 | |
| 29282.10915 | 1 | |
| 27296.48576 | 1 | |
| 26268.69989 | 1 | |
| 26194.04954 | 1 | |
| 23130.82106 | 1 | |
| 22665.7785 | 1 | |
| 21943.84942 | 1 | |
| 20712.67008 | 1 | |
| 20277.33112 | 1 |
PURCHASES_FREQUENCY
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 47 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.49035055 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 2043 |
| Zeros (%) | 22.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.083333 |
| median | 0.5 |
| Q3 | 0.916667 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.833334 |
Descriptive statistics
| Standard deviation | 0.40137075 |
|---|---|
| Coefficient of variation (CV) | 0.81853839 |
| Kurtosis | -1.6386309 |
| Mean | 0.49035055 |
| Median Absolute Deviation (MAD) | 0.416667 |
| Skewness | 0.060164236 |
| Sum | 4388.6374 |
| Variance | 0.16109848 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=47)
| Value | Count | Frequency (%) |
| 1 | 2178 | |
| 0 | 2043 | |
| 0.083333 | 677 | 7.6% |
| 0.916667 | 396 | 4.4% |
| 0.5 | 395 | 4.4% |
| 0.166667 | 392 | 4.4% |
| 0.833333 | 373 | 4.2% |
| 0.333333 | 367 | 4.1% |
| 0.25 | 345 | 3.9% |
| 0.583333 | 316 | 3.5% |
| Other values (37) | 1468 |
| Value | Count | Frequency (%) |
| 0 | 2043 | |
| 0.083333 | 677 | 7.6% |
| 0.090909 | 43 | 0.5% |
| 0.1 | 27 | 0.3% |
| 0.111111 | 18 | 0.2% |
| 0.125 | 32 | 0.4% |
| 0.142857 | 26 | 0.3% |
| 0.166667 | 392 | 4.4% |
| 0.181818 | 16 | 0.2% |
| 0.2 | 19 | 0.2% |
| Value | Count | Frequency (%) |
| 1 | 2178 | |
| 0.916667 | 396 | 4.4% |
| 0.909091 | 28 | 0.3% |
| 0.9 | 24 | 0.3% |
| 0.888889 | 18 | 0.2% |
| 0.875 | 26 | 0.3% |
| 0.857143 | 25 | 0.3% |
| 0.833333 | 373 | 4.2% |
| 0.818182 | 21 | 0.2% |
| 0.8 | 9 | 0.1% |
ONEOFF_PURCHASES_FREQUENCY
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 47 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.20245768 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 4302 |
| Zeros (%) | 48.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.083333 |
| Q3 | 0.3 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.3 |
Descriptive statistics
| Standard deviation | 0.29833607 |
|---|---|
| Coefficient of variation (CV) | 1.4735725 |
| Kurtosis | 1.1618456 |
| Mean | 0.20245768 |
| Median Absolute Deviation (MAD) | 0.083333 |
| Skewness | 1.5356128 |
| Sum | 1811.9963 |
| Variance | 0.089004408 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=47)
| Value | Count | Frequency (%) |
| 0 | 4302 | |
| 0.083333 | 1104 | 12.3% |
| 0.166667 | 592 | 6.6% |
| 1 | 481 | 5.4% |
| 0.25 | 418 | 4.7% |
| 0.333333 | 355 | 4.0% |
| 0.416667 | 244 | 2.7% |
| 0.5 | 235 | 2.6% |
| 0.583333 | 197 | 2.2% |
| 0.666667 | 167 | 1.9% |
| Other values (37) | 855 | 9.6% |
| Value | Count | Frequency (%) |
| 0 | 4302 | |
| 0.083333 | 1104 | 12.3% |
| 0.090909 | 56 | 0.6% |
| 0.1 | 39 | 0.4% |
| 0.111111 | 26 | 0.3% |
| 0.125 | 41 | 0.5% |
| 0.142857 | 37 | 0.4% |
| 0.166667 | 592 | 6.6% |
| 0.181818 | 34 | 0.4% |
| 0.2 | 27 | 0.3% |
| Value | Count | Frequency (%) |
| 1 | 481 | |
| 0.916667 | 151 | 1.7% |
| 0.909091 | 4 | < 0.1% |
| 0.9 | 1 | < 0.1% |
| 0.888889 | 2 | < 0.1% |
| 0.875 | 6 | 0.1% |
| 0.857143 | 1 | < 0.1% |
| 0.833333 | 120 | 1.3% |
| 0.818182 | 10 | 0.1% |
| 0.8 | 4 | < 0.1% |
PURCHASES_INSTALLMENTS_FREQUENCY
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 47 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.36443734 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 3915 |
| Zeros (%) | 43.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.166667 |
| Q3 | 0.75 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.75 |
Descriptive statistics
| Standard deviation | 0.39744778 |
|---|---|
| Coefficient of variation (CV) | 1.0905792 |
| Kurtosis | -1.3986322 |
| Mean | 0.36443734 |
| Median Absolute Deviation (MAD) | 0.166667 |
| Skewness | 0.50920116 |
| Sum | 3261.7142 |
| Variance | 0.15796474 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=47)
| Value | Count | Frequency (%) |
| 0 | 3915 | |
| 1 | 1331 | 14.9% |
| 0.416667 | 388 | 4.3% |
| 0.916667 | 345 | 3.9% |
| 0.833333 | 311 | 3.5% |
| 0.5 | 310 | 3.5% |
| 0.166667 | 305 | 3.4% |
| 0.666667 | 292 | 3.3% |
| 0.75 | 291 | 3.3% |
| 0.083333 | 275 | 3.1% |
| Other values (37) | 1187 | 13.3% |
| Value | Count | Frequency (%) |
| 0 | 3915 | |
| 0.083333 | 275 | 3.1% |
| 0.090909 | 12 | 0.1% |
| 0.1 | 6 | 0.1% |
| 0.111111 | 9 | 0.1% |
| 0.125 | 5 | 0.1% |
| 0.142857 | 6 | 0.1% |
| 0.166667 | 305 | 3.4% |
| 0.181818 | 14 | 0.2% |
| 0.2 | 9 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 1331 | |
| 0.916667 | 345 | 3.9% |
| 0.909091 | 25 | 0.3% |
| 0.9 | 19 | 0.2% |
| 0.888889 | 28 | 0.3% |
| 0.875 | 28 | 0.3% |
| 0.857143 | 30 | 0.3% |
| 0.833333 | 311 | 3.5% |
| 0.818182 | 21 | 0.2% |
| 0.8 | 18 | 0.2% |
CASH_ADVANCE_FREQUENCY
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 54 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1351442 |
| Minimum | 0 |
|---|---|
| Maximum | 1.5 |
| Zeros | 4628 |
| Zeros (%) | 51.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.222222 |
| 95-th percentile | 0.583333 |
| Maximum | 1.5 |
| Range | 1.5 |
| Interquartile range (IQR) | 0.222222 |
Descriptive statistics
| Standard deviation | 0.20012139 |
|---|---|
| Coefficient of variation (CV) | 1.4807989 |
| Kurtosis | 3.3347343 |
| Mean | 0.1351442 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.8286863 |
| Sum | 1209.5406 |
| Variance | 0.04004857 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 4628 | |
| 0.083333 | 1021 | 11.4% |
| 0.166667 | 759 | 8.5% |
| 0.25 | 578 | 6.5% |
| 0.333333 | 439 | 4.9% |
| 0.416667 | 273 | 3.1% |
| 0.5 | 215 | 2.4% |
| 0.583333 | 142 | 1.6% |
| 0.666667 | 125 | 1.4% |
| 0.090909 | 70 | 0.8% |
| Other values (44) | 700 | 7.8% |
| Value | Count | Frequency (%) |
| 0 | 4628 | |
| 0.083333 | 1021 | 11.4% |
| 0.090909 | 70 | 0.8% |
| 0.1 | 39 | 0.4% |
| 0.111111 | 29 | 0.3% |
| 0.125 | 47 | 0.5% |
| 0.142857 | 49 | 0.5% |
| 0.166667 | 759 | 8.5% |
| 0.181818 | 42 | 0.5% |
| 0.2 | 21 | 0.2% |
| Value | Count | Frequency (%) |
| 1.5 | 1 | < 0.1% |
| 1.25 | 1 | < 0.1% |
| 1.166667 | 2 | < 0.1% |
| 1.142857 | 1 | < 0.1% |
| 1.125 | 1 | < 0.1% |
| 1.1 | 1 | < 0.1% |
| 1.090909 | 1 | < 0.1% |
| 1 | 25 | |
| 0.916667 | 27 | |
| 0.909091 | 3 | < 0.1% |
CASH_ADVANCE_TRX
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 65 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.2488268 |
| Minimum | 0 |
|---|---|
| Maximum | 123 |
| Zeros | 4628 |
| Zeros (%) | 51.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 4 |
| 95-th percentile | 15 |
| Maximum | 123 |
| Range | 123 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 6.8246467 |
|---|---|
| Coefficient of variation (CV) | 2.1006496 |
| Kurtosis | 61.646862 |
| Mean | 3.2488268 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.7212982 |
| Sum | 29077 |
| Variance | 46.575803 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 4628 | |
| 1 | 887 | 9.9% |
| 2 | 620 | 6.9% |
| 3 | 436 | 4.9% |
| 4 | 384 | 4.3% |
| 5 | 308 | 3.4% |
| 6 | 246 | 2.7% |
| 7 | 205 | 2.3% |
| 8 | 171 | 1.9% |
| 10 | 150 | 1.7% |
| Other values (55) | 915 | 10.2% |
| Value | Count | Frequency (%) |
| 0 | 4628 | |
| 1 | 887 | 9.9% |
| 2 | 620 | 6.9% |
| 3 | 436 | 4.9% |
| 4 | 384 | 4.3% |
| 5 | 308 | 3.4% |
| 6 | 246 | 2.7% |
| 7 | 205 | 2.3% |
| 8 | 171 | 1.9% |
| 9 | 111 | 1.2% |
| Value | Count | Frequency (%) |
| 123 | 3 | |
| 110 | 1 | < 0.1% |
| 107 | 1 | < 0.1% |
| 93 | 1 | < 0.1% |
| 80 | 1 | < 0.1% |
| 71 | 1 | < 0.1% |
| 69 | 1 | < 0.1% |
| 63 | 1 | < 0.1% |
| 62 | 3 | |
| 61 | 1 | < 0.1% |
PURCHASES_TRX
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 173 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.709832 |
| Minimum | 0 |
|---|---|
| Maximum | 358 |
| Zeros | 2044 |
| Zeros (%) | 22.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 7 |
| Q3 | 17 |
| 95-th percentile | 57 |
| Maximum | 358 |
| Range | 358 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 24.857649 |
|---|---|
| Coefficient of variation (CV) | 1.6898662 |
| Kurtosis | 34.7931 |
| Mean | 14.709832 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 4.6306553 |
| Sum | 131653 |
| Variance | 617.90272 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 2044 | |
| 1 | 667 | 7.5% |
| 12 | 570 | 6.4% |
| 2 | 379 | 4.2% |
| 6 | 352 | 3.9% |
| 3 | 314 | 3.5% |
| 4 | 285 | 3.2% |
| 7 | 275 | 3.1% |
| 5 | 267 | 3.0% |
| 8 | 267 | 3.0% |
| Other values (163) | 3530 |
| Value | Count | Frequency (%) |
| 0 | 2044 | |
| 1 | 667 | 7.5% |
| 2 | 379 | 4.2% |
| 3 | 314 | 3.5% |
| 4 | 285 | 3.2% |
| 5 | 267 | 3.0% |
| 6 | 352 | 3.9% |
| 7 | 275 | 3.1% |
| 8 | 267 | 3.0% |
| 9 | 248 | 2.8% |
| Value | Count | Frequency (%) |
| 358 | 1 | |
| 347 | 1 | |
| 344 | 1 | |
| 309 | 1 | |
| 308 | 1 | |
| 298 | 1 | |
| 274 | 1 | |
| 273 | 1 | |
| 254 | 1 | |
| 248 | 2 |
CREDIT_LIMIT
Real number (ℝ)
| Distinct | 205 |
|---|---|
| Distinct (%) | 2.3% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4494.4495 |
| Minimum | 50 |
|---|---|
| Maximum | 30000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 50 |
|---|---|
| 5-th percentile | 1000 |
| Q1 | 1600 |
| median | 3000 |
| Q3 | 6500 |
| 95-th percentile | 12000 |
| Maximum | 30000 |
| Range | 29950 |
| Interquartile range (IQR) | 4900 |
Descriptive statistics
| Standard deviation | 3638.8157 |
|---|---|
| Coefficient of variation (CV) | 0.80962435 |
| Kurtosis | 2.8366559 |
| Mean | 4494.4495 |
| Median Absolute Deviation (MAD) | 1800 |
| Skewness | 1.522464 |
| Sum | 40220828 |
| Variance | 13240980 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3000 | 784 | 8.8% |
| 1500 | 722 | 8.1% |
| 1200 | 621 | 6.9% |
| 1000 | 614 | 6.9% |
| 2500 | 612 | 6.8% |
| 4000 | 506 | 5.7% |
| 6000 | 463 | 5.2% |
| 5000 | 389 | 4.3% |
| 2000 | 371 | 4.1% |
| 7500 | 277 | 3.1% |
| Other values (195) | 3590 |
| Value | Count | Frequency (%) |
| 50 | 1 | < 0.1% |
| 150 | 5 | 0.1% |
| 200 | 3 | < 0.1% |
| 300 | 14 | 0.2% |
| 400 | 3 | < 0.1% |
| 450 | 6 | 0.1% |
| 500 | 121 | |
| 600 | 21 | 0.2% |
| 650 | 1 | < 0.1% |
| 700 | 20 | 0.2% |
| Value | Count | Frequency (%) |
| 30000 | 2 | < 0.1% |
| 28000 | 1 | < 0.1% |
| 25000 | 1 | < 0.1% |
| 23000 | 2 | < 0.1% |
| 22500 | 1 | < 0.1% |
| 22000 | 1 | < 0.1% |
| 21500 | 2 | < 0.1% |
| 21000 | 2 | < 0.1% |
| 20500 | 1 | < 0.1% |
| 20000 | 10 |
PAYMENTS
Real number (ℝ)
| Distinct | 8711 |
|---|---|
| Distinct (%) | 97.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1733.1439 |
| Minimum | 0 |
|---|---|
| Maximum | 50721.483 |
| Zeros | 240 |
| Zeros (%) | 2.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 89.988924 |
| Q1 | 383.27617 |
| median | 856.90155 |
| Q3 | 1901.1343 |
| 95-th percentile | 6082.0906 |
| Maximum | 50721.483 |
| Range | 50721.483 |
| Interquartile range (IQR) | 1517.8582 |
Descriptive statistics
| Standard deviation | 2895.0638 |
|---|---|
| Coefficient of variation (CV) | 1.6704117 |
| Kurtosis | 54.770736 |
| Mean | 1733.1439 |
| Median Absolute Deviation (MAD) | 581.35146 |
| Skewness | 5.9076198 |
| Sum | 15511637 |
| Variance | 8381394.2 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 240 | 2.7% |
| 201.802084 | 1 | < 0.1% |
| 398.316441 | 1 | < 0.1% |
| 826.036748 | 1 | < 0.1% |
| 2571.573214 | 1 | < 0.1% |
| 1903.279643 | 1 | < 0.1% |
| 454.888506 | 1 | < 0.1% |
| 956.028747 | 1 | < 0.1% |
| 4560.77572 | 1 | < 0.1% |
| 1825.349955 | 1 | < 0.1% |
| Other values (8701) | 8701 |
| Value | Count | Frequency (%) |
| 0 | 240 | |
| 0.049513 | 1 | < 0.1% |
| 0.056466 | 1 | < 0.1% |
| 2.389583 | 1 | < 0.1% |
| 3.500505 | 1 | < 0.1% |
| 4.523555 | 1 | < 0.1% |
| 4.841543 | 1 | < 0.1% |
| 5.070726 | 1 | < 0.1% |
| 9.040017 | 1 | < 0.1% |
| 9.533313 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 50721.48336 | 1 | |
| 46930.59824 | 1 | |
| 40627.59524 | 1 | |
| 39461.9658 | 1 | |
| 39048.59762 | 1 | |
| 36066.75068 | 1 | |
| 35843.62593 | 1 | |
| 34107.07499 | 1 | |
| 33994.72785 | 1 | |
| 33486.31044 | 1 |
MINIMUM_PAYMENTS
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 8636 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 313 |
| Missing (%) | 3.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 864.20654 |
| Minimum | 0.019163 |
|---|---|
| Maximum | 76406.208 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0.019163 |
|---|---|
| 5-th percentile | 73.282006 |
| Q1 | 169.12371 |
| median | 312.34395 |
| Q3 | 825.48546 |
| 95-th percentile | 2766.5633 |
| Maximum | 76406.208 |
| Range | 76406.188 |
| Interquartile range (IQR) | 656.36175 |
Descriptive statistics
| Standard deviation | 2372.4466 |
|---|---|
| Coefficient of variation (CV) | 2.745231 |
| Kurtosis | 283.98999 |
| Mean | 864.20654 |
| Median Absolute Deviation (MAD) | 190.3741 |
| Skewness | 13.622797 |
| Sum | 7464151.9 |
| Variance | 5628502.9 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 299.351881 | 2 | < 0.1% |
| 150.317143 | 1 | < 0.1% |
| 271.528169 | 1 | < 0.1% |
| 6404.855484 | 1 | < 0.1% |
| 616.862544 | 1 | < 0.1% |
| 211.984193 | 1 | < 0.1% |
| 324.954747 | 1 | < 0.1% |
| 1600.26917 | 1 | < 0.1% |
| 277.546713 | 1 | < 0.1% |
| 342.28649 | 1 | < 0.1% |
| Other values (8626) | 8626 | |
| (Missing) | 313 | 3.5% |
| Value | Count | Frequency (%) |
| 0.019163 | 1 | |
| 0.037744 | 1 | |
| 0.05588 | 1 | |
| 0.059481 | 1 | |
| 0.117036 | 1 | |
| 0.261984 | 1 | |
| 0.311953 | 1 | |
| 0.319475 | 1 | |
| 1.113027 | 1 | |
| 1.334075 | 1 |
| Value | Count | Frequency (%) |
| 76406.20752 | 1 | |
| 61031.6186 | 1 | |
| 56370.04117 | 1 | |
| 50260.75947 | 1 | |
| 43132.72823 | 1 | |
| 42629.55117 | 1 | |
| 38512.12477 | 1 | |
| 31871.36379 | 1 | |
| 30528.4324 | 1 | |
| 29019.80288 | 1 |
PRC_FULL_PAYMENT
Real number (ℝ)
| Distinct | 47 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.15371465 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 5903 |
| Zeros (%) | 66.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.142857 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.142857 |
Descriptive statistics
| Standard deviation | 0.2924992 |
|---|---|
| Coefficient of variation (CV) | 1.9028713 |
| Kurtosis | 2.4323953 |
| Mean | 0.15371465 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.9428199 |
| Sum | 1375.7461 |
| Variance | 0.08555578 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=47)
| Value | Count | Frequency (%) |
| 0 | 5903 | |
| 1 | 488 | 5.5% |
| 0.083333 | 426 | 4.8% |
| 0.166667 | 166 | 1.9% |
| 0.5 | 156 | 1.7% |
| 0.25 | 156 | 1.7% |
| 0.090909 | 153 | 1.7% |
| 0.333333 | 134 | 1.5% |
| 0.1 | 94 | 1.1% |
| 0.2 | 83 | 0.9% |
| Other values (37) | 1191 | 13.3% |
| Value | Count | Frequency (%) |
| 0 | 5903 | |
| 0.083333 | 426 | 4.8% |
| 0.090909 | 153 | 1.7% |
| 0.1 | 94 | 1.1% |
| 0.111111 | 61 | 0.7% |
| 0.125 | 52 | 0.6% |
| 0.142857 | 54 | 0.6% |
| 0.166667 | 166 | 1.9% |
| 0.181818 | 75 | 0.8% |
| 0.2 | 83 | 0.9% |
| Value | Count | Frequency (%) |
| 1 | 488 | |
| 0.916667 | 77 | 0.9% |
| 0.909091 | 19 | 0.2% |
| 0.9 | 16 | 0.2% |
| 0.888889 | 12 | 0.1% |
| 0.875 | 18 | 0.2% |
| 0.857143 | 12 | 0.1% |
| 0.833333 | 63 | 0.7% |
| 0.818182 | 17 | 0.2% |
| 0.8 | 33 | 0.4% |
TENURE
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.517318 |
| Minimum | 6 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 70.0 KiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 12 |
| median | 12 |
| Q3 | 12 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 6 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.3383308 |
|---|---|
| Coefficient of variation (CV) | 0.11620159 |
| Kurtosis | 7.6948232 |
| Mean | 11.517318 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.9430173 |
| Sum | 103080 |
| Variance | 1.7911292 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 12 | 7584 | |
| 11 | 365 | 4.1% |
| 10 | 236 | 2.6% |
| 6 | 204 | 2.3% |
| 8 | 196 | 2.2% |
| 7 | 190 | 2.1% |
| 9 | 175 | 2.0% |
| Value | Count | Frequency (%) |
| 6 | 204 | 2.3% |
| 7 | 190 | 2.1% |
| 8 | 196 | 2.2% |
| 9 | 175 | 2.0% |
| 10 | 236 | 2.6% |
| 11 | 365 | 4.1% |
| 12 | 7584 |
| Value | Count | Frequency (%) |
| 12 | 7584 | |
| 11 | 365 | 4.1% |
| 10 | 236 | 2.6% |
| 9 | 175 | 2.0% |
| 8 | 196 | 2.2% |
| 7 | 190 | 2.1% |
| 6 | 204 | 2.3% |
| BALANCE | BALANCE_FREQUENCY | PURCHASES | ONEOFF_PURCHASES | INSTALLMENTS_PURCHASES | CASH_ADVANCE | PURCHASES_FREQUENCY | ONEOFF_PURCHASES_FREQUENCY | PURCHASES_INSTALLMENTS_FREQUENCY | CASH_ADVANCE_FREQUENCY | CASH_ADVANCE_TRX | PURCHASES_TRX | CREDIT_LIMIT | PAYMENTS | MINIMUM_PAYMENTS | PRC_FULL_PAYMENT | TENURE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BALANCE | 1.000 | 0.545 | 0.006 | 0.146 | -0.090 | 0.566 | -0.145 | 0.120 | -0.144 | 0.544 | 0.549 | -0.046 | 0.372 | 0.432 | 0.900 | -0.484 | 0.066 |
| BALANCE_FREQUENCY | 0.545 | 1.000 | 0.148 | 0.135 | 0.128 | 0.137 | 0.202 | 0.159 | 0.152 | 0.177 | 0.176 | 0.203 | 0.106 | 0.207 | 0.502 | -0.174 | 0.229 |
| PURCHASES | 0.006 | 0.148 | 1.000 | 0.751 | 0.706 | -0.385 | 0.795 | 0.693 | 0.606 | -0.391 | -0.384 | 0.885 | 0.261 | 0.395 | -0.008 | 0.238 | 0.133 |
| ONEOFF_PURCHASES | 0.146 | 0.135 | 0.751 | 1.000 | 0.200 | -0.185 | 0.424 | 0.952 | 0.117 | -0.179 | -0.175 | 0.590 | 0.305 | 0.363 | 0.070 | 0.049 | 0.096 |
| INSTALLMENTS_PURCHASES | -0.090 | 0.128 | 0.706 | 0.200 | 1.000 | -0.357 | 0.786 | 0.185 | 0.923 | -0.366 | -0.357 | 0.784 | 0.123 | 0.239 | -0.052 | 0.276 | 0.125 |
| CASH_ADVANCE | 0.566 | 0.137 | -0.385 | -0.185 | -0.357 | 1.000 | -0.454 | -0.189 | -0.378 | 0.941 | 0.952 | -0.408 | 0.163 | 0.257 | 0.482 | -0.266 | -0.113 |
| PURCHASES_FREQUENCY | -0.145 | 0.202 | 0.795 | 0.424 | 0.786 | -0.454 | 1.000 | 0.463 | 0.852 | -0.453 | -0.447 | 0.924 | 0.104 | 0.172 | -0.104 | 0.292 | 0.098 |
| ONEOFF_PURCHASES_FREQUENCY | 0.120 | 0.159 | 0.693 | 0.952 | 0.185 | -0.189 | 0.463 | 1.000 | 0.112 | -0.176 | -0.174 | 0.607 | 0.282 | 0.321 | 0.051 | 0.061 | 0.084 |
| PURCHASES_INSTALLMENTS_FREQUENCY | -0.144 | 0.152 | 0.606 | 0.117 | 0.923 | -0.378 | 0.852 | 0.112 | 1.000 | -0.382 | -0.374 | 0.781 | 0.047 | 0.121 | -0.085 | 0.259 | 0.114 |
| CASH_ADVANCE_FREQUENCY | 0.544 | 0.177 | -0.391 | -0.179 | -0.366 | 0.941 | -0.453 | -0.176 | -0.382 | 1.000 | 0.983 | -0.407 | 0.088 | 0.203 | 0.456 | -0.287 | -0.131 |
| CASH_ADVANCE_TRX | 0.549 | 0.176 | -0.384 | -0.175 | -0.357 | 0.952 | -0.447 | -0.174 | -0.374 | 0.983 | 1.000 | -0.399 | 0.097 | 0.215 | 0.472 | -0.281 | -0.099 |
| PURCHASES_TRX | -0.046 | 0.203 | 0.885 | 0.590 | 0.784 | -0.408 | 0.924 | 0.607 | 0.781 | -0.407 | -0.399 | 1.000 | 0.190 | 0.284 | -0.025 | 0.253 | 0.169 |
| CREDIT_LIMIT | 0.372 | 0.106 | 0.261 | 0.305 | 0.123 | 0.163 | 0.104 | 0.282 | 0.047 | 0.088 | 0.097 | 0.190 | 1.000 | 0.449 | 0.264 | 0.021 | 0.170 |
| PAYMENTS | 0.432 | 0.207 | 0.395 | 0.363 | 0.239 | 0.257 | 0.172 | 0.321 | 0.121 | 0.203 | 0.215 | 0.284 | 0.449 | 1.000 | 0.368 | 0.187 | 0.205 |
| MINIMUM_PAYMENTS | 0.900 | 0.502 | -0.008 | 0.070 | -0.052 | 0.482 | -0.104 | 0.051 | -0.085 | 0.456 | 0.472 | -0.025 | 0.264 | 0.368 | 1.000 | -0.478 | 0.137 |
| PRC_FULL_PAYMENT | -0.484 | -0.174 | 0.238 | 0.049 | 0.276 | -0.266 | 0.292 | 0.061 | 0.259 | -0.287 | -0.281 | 0.253 | 0.021 | 0.187 | -0.478 | 1.000 | 0.020 |
| TENURE | 0.066 | 0.229 | 0.133 | 0.096 | 0.125 | -0.113 | 0.098 | 0.084 | 0.114 | -0.131 | -0.099 | 0.169 | 0.170 | 0.205 | 0.137 | 0.020 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| CUST_ID | BALANCE | BALANCE_FREQUENCY | PURCHASES | ONEOFF_PURCHASES | INSTALLMENTS_PURCHASES | CASH_ADVANCE | PURCHASES_FREQUENCY | ONEOFF_PURCHASES_FREQUENCY | PURCHASES_INSTALLMENTS_FREQUENCY | CASH_ADVANCE_FREQUENCY | CASH_ADVANCE_TRX | PURCHASES_TRX | CREDIT_LIMIT | PAYMENTS | MINIMUM_PAYMENTS | PRC_FULL_PAYMENT | TENURE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | C10001 | 40.900749 | 0.818182 | 95.40 | 0.00 | 95.40 | 0.000000 | 0.166667 | 0.000000 | 0.083333 | 0.000000 | 0 | 2 | 1000.0 | 201.802084 | 139.509787 | 0.000000 | 12 |
| 1 | C10002 | 3202.467416 | 0.909091 | 0.00 | 0.00 | 0.00 | 6442.945483 | 0.000000 | 0.000000 | 0.000000 | 0.250000 | 4 | 0 | 7000.0 | 4103.032597 | 1072.340217 | 0.222222 | 12 |
| 2 | C10003 | 2495.148862 | 1.000000 | 773.17 | 773.17 | 0.00 | 0.000000 | 1.000000 | 1.000000 | 0.000000 | 0.000000 | 0 | 12 | 7500.0 | 622.066742 | 627.284787 | 0.000000 | 12 |
| 3 | C10004 | 1666.670542 | 0.636364 | 1499.00 | 1499.00 | 0.00 | 205.788017 | 0.083333 | 0.083333 | 0.000000 | 0.083333 | 1 | 1 | 7500.0 | 0.000000 | NaN | 0.000000 | 12 |
| 4 | C10005 | 817.714335 | 1.000000 | 16.00 | 16.00 | 0.00 | 0.000000 | 0.083333 | 0.083333 | 0.000000 | 0.000000 | 0 | 1 | 1200.0 | 678.334763 | 244.791237 | 0.000000 | 12 |
| 5 | C10006 | 1809.828751 | 1.000000 | 1333.28 | 0.00 | 1333.28 | 0.000000 | 0.666667 | 0.000000 | 0.583333 | 0.000000 | 0 | 8 | 1800.0 | 1400.057770 | 2407.246035 | 0.000000 | 12 |
| 6 | C10007 | 627.260806 | 1.000000 | 7091.01 | 6402.63 | 688.38 | 0.000000 | 1.000000 | 1.000000 | 1.000000 | 0.000000 | 0 | 64 | 13500.0 | 6354.314328 | 198.065894 | 1.000000 | 12 |
| 7 | C10008 | 1823.652743 | 1.000000 | 436.20 | 0.00 | 436.20 | 0.000000 | 1.000000 | 0.000000 | 1.000000 | 0.000000 | 0 | 12 | 2300.0 | 679.065082 | 532.033990 | 0.000000 | 12 |
| 8 | C10009 | 1014.926473 | 1.000000 | 861.49 | 661.49 | 200.00 | 0.000000 | 0.333333 | 0.083333 | 0.250000 | 0.000000 | 0 | 5 | 7000.0 | 688.278568 | 311.963409 | 0.000000 | 12 |
| 9 | C10010 | 152.225975 | 0.545455 | 1281.60 | 1281.60 | 0.00 | 0.000000 | 0.166667 | 0.166667 | 0.000000 | 0.000000 | 0 | 3 | 11000.0 | 1164.770591 | 100.302262 | 0.000000 | 12 |
| CUST_ID | BALANCE | BALANCE_FREQUENCY | PURCHASES | ONEOFF_PURCHASES | INSTALLMENTS_PURCHASES | CASH_ADVANCE | PURCHASES_FREQUENCY | ONEOFF_PURCHASES_FREQUENCY | PURCHASES_INSTALLMENTS_FREQUENCY | CASH_ADVANCE_FREQUENCY | CASH_ADVANCE_TRX | PURCHASES_TRX | CREDIT_LIMIT | PAYMENTS | MINIMUM_PAYMENTS | PRC_FULL_PAYMENT | TENURE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8940 | C19181 | 130.838554 | 1.000000 | 591.24 | 0.00 | 591.24 | 0.000000 | 1.000000 | 0.000000 | 0.833333 | 0.000000 | 0 | 6 | 1000.0 | 475.523262 | 82.771320 | 1.00 | 6 |
| 8941 | C19182 | 5967.475270 | 0.833333 | 214.55 | 0.00 | 214.55 | 8555.409326 | 0.833333 | 0.000000 | 0.666667 | 0.666667 | 13 | 5 | 9000.0 | 966.202912 | 861.949906 | 0.00 | 6 |
| 8942 | C19183 | 40.829749 | 1.000000 | 113.28 | 0.00 | 113.28 | 0.000000 | 1.000000 | 0.000000 | 0.833333 | 0.000000 | 0 | 6 | 1000.0 | 94.488828 | 86.283101 | 0.25 | 6 |
| 8943 | C19184 | 5.871712 | 0.500000 | 20.90 | 20.90 | 0.00 | 0.000000 | 0.166667 | 0.166667 | 0.000000 | 0.000000 | 0 | 1 | 500.0 | 58.644883 | 43.473717 | 0.00 | 6 |
| 8944 | C19185 | 193.571722 | 0.833333 | 1012.73 | 1012.73 | 0.00 | 0.000000 | 0.333333 | 0.333333 | 0.000000 | 0.000000 | 0 | 2 | 4000.0 | 0.000000 | NaN | 0.00 | 6 |
| 8945 | C19186 | 28.493517 | 1.000000 | 291.12 | 0.00 | 291.12 | 0.000000 | 1.000000 | 0.000000 | 0.833333 | 0.000000 | 0 | 6 | 1000.0 | 325.594462 | 48.886365 | 0.50 | 6 |
| 8946 | C19187 | 19.183215 | 1.000000 | 300.00 | 0.00 | 300.00 | 0.000000 | 1.000000 | 0.000000 | 0.833333 | 0.000000 | 0 | 6 | 1000.0 | 275.861322 | NaN | 0.00 | 6 |
| 8947 | C19188 | 23.398673 | 0.833333 | 144.40 | 0.00 | 144.40 | 0.000000 | 0.833333 | 0.000000 | 0.666667 | 0.000000 | 0 | 5 | 1000.0 | 81.270775 | 82.418369 | 0.25 | 6 |
| 8948 | C19189 | 13.457564 | 0.833333 | 0.00 | 0.00 | 0.00 | 36.558778 | 0.000000 | 0.000000 | 0.000000 | 0.166667 | 2 | 0 | 500.0 | 52.549959 | 55.755628 | 0.25 | 6 |
| 8949 | C19190 | 372.708075 | 0.666667 | 1093.25 | 1093.25 | 0.00 | 127.040008 | 0.666667 | 0.666667 | 0.000000 | 0.333333 | 2 | 23 | 1200.0 | 63.165404 | 88.288956 | 0.00 | 6 |